workgrouptype
Table: workgrouptype
The workgrouptype table stores types of workgroups and their metadata.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| workgrouptypeId | int(11) | NO | Primary key for workgroup type |
| workgroupName | varchar(45) | YES | Name of the workgroup type |
| createdByUserId | int(11) | YES | User who created the record |
| lastEditedByUserId | int(11) | YES | User who last edited the record |
| createdDate | datetime | YES | Record creation timestamp |
| lastEditedDate | datetime | YES | Record last edited timestamp |
| assignedLatitude | varchar(255) | YES | Latitude assigned to the group |
| assignedLongitude | varchar(255) | YES | Longitude assigned to the group |
Indexes
createdBy_FK_idx— Index oncreatedByUserIdeditedBy_FK_idx— Index onlastEditedByUserId
Foreign Key Relations
createdByUserId → user.mappedIdlastEditedByUserId → user.mappedId
Usage Notes
- Stores metadata for workgroup types including location coordinates.